--------------------------------------------------------------------------------------
Use NovoSiscom
--------------------------------------------------------------------------------------
SELECT * FROM ClienteCrypt
--------------------------------------------------------------------------------------
SELECT	Col1															AS Cod_Cli, 	
		Cast(DecryptByPassPhrase('Frase Secreta',Col2)AS varchar(50))	AS Nome_Cli,
		Cast(DecryptByPassPhrase('Frase Secreta',Col3)AS varchar(60))	AS End_Cli,
		Cast(DecryptByPassPhrase('Frase Secreta',Col4)AS varchar(20))	AS Bairro_Cli,
		Cast(DecryptByPassPhrase('Frase Secreta',Col5)AS varchar(20))	AS Cid_Cli,
		Cast(DecryptByPassPhrase('Frase Secreta',Col6)AS varchar(2))	AS Sigla_Est,	
		Cast(DecryptByPassPhrase('Frase Secreta',Col7)AS varchar(8))	AS Cep_Cli,
		Cast(DecryptByPassPhrase('Frase Secreta',Col8)AS varchar(18))	AS CGC_Cli,
		Cast(DecryptByPassPhrase('Frase Secreta',Col9)AS varchar(19))	AS InscEst_Cli,
		Col10 AS DataCad_Cli
FROM ClienteCrypt
--------------------------------------------------------------------------------------